SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Marvellous contemporary cape in move-in condition with fabulous gleaming hardwood floors throughout the main level. Open first floor has spacious kitchen, dining room, living room, mudroom, office and 1/2 bath/laundry. Second floor has 3 bedrooms, 2 full bathrooms. Separate suite, accessed from mudroom has large living room or home office, bedroom, and 3/4 bath. This residential neighborhood location makes for quick and easy commuting to the medical center, without driving through Hanover, or to the College. A great one! Showings start at Open House Saturday, Jan 4, 10am-12 and Sunday, Jan 5, 2-4pm
Description:Completed in 2023, this hilltop passion project is one of a kind. Located on one of the highest points in Grantham, this property has nearly 270 degree views, including nearby peaks like Grantham Mountain and Croydon Mountain, as well as distant peaks like Mt. Kearsarge, Mt. Sunapee, and Mt. Cardigan. Sited on 9.41 acres, this home has privacy on all sides, and is nicely hidden from the street. A solar tracker at the top of the hill powers the entire home for about 9 months out of the year. The home is all electric, utilizing energy efficient heat pumps for both winter heat and summer A/C. The layout of the home is open concept with 22ft+ ceilings in the central living area and views from every room. The main section includes a floor to ceiling fireplace, an expansive dining area, sunroom corner, and a designer kitchen with an oversized island. Off the kitchen is a guest room with vaulted ceilings and custom built barn doors that allow for privacy when needed, and sunlight/views when the room is not in use. The upstairs loft serves as a 3rd bedroom or office, and has an adjacent full bath and large closet. Back on the main floor, the master bedroom faces south toward Mt. Sunapee, with daily sunrises and sunsets visible from each set of windows. The suite includes a large walk-through closet with custom built-ins, and a master bathroom that has an expansive tiled shower and dual vanity. The basement/garage is also heated, and is large enough to fit 3 vehicles and a tractor.
Description:Gorgeous Lakefront! From the moment you enter this newly renovated contemporary home, you will be greeted with views and sunshine. Luxurious renovations include a high end designer chef's kitchen with Induction Wolf Range, double ovens and built-in microwave, Sub Zero Refrigerator, Bosch Dishwasher, elegant wine cooler and gorgeous counters opening to the sun filled dining area.The easy open flow and abundant windows framing the exquisite views are sure to impress you, while the quality craftsmanship can be observed in every room from the two center stone fireplaces to the custom Dana Robes built cherry shelving. Not only do you have a light bright open floor plan with main level ensuite primary bedroom/ bath and a wrap around deck overlooking the water but you also enjoy 3 other bedroom and home office options complimented by 4 beautifully renovated custom bathrooms including the primary suite bath with sumptuous sauna. The Village abuts acres of conserved land for you to explore and the local rail trail is nearby for hiking and biking pleasure. This little piece of paradise also includes an attached two car garage, beautiful stonewalls and is located only minutes from Dartmouth Health, Dartmouth College and Mt. Cardigan. (virtual staging used)
Description:7 WILLOW SPRING LANE- Spacious, well-maintained home on a large private lot in a quiet neighborhood within walking distance of downtown Hanover. The Girl Brook Trail and Dartmouth's Practice Golf Course are adjacent the property providing acres of space to recreate. The house interiors are spacious and bright, including a large living room with central fireplace and views over the back lawn on the main level. There is a large, well-appointed eat-in kitchen that adjoins a formal dining room, while the primary bedroom suite on this level features a generous en suite bathroom, changing area, and plenty of wardrobe space. There is also a second en suite bedroom on this floor providing plenty of options for one-floor living. The lower walkout level offers several versatile bright and spacious rooms including a family room, rec room, and two additional bedrooms that share a full bathroom. Additionally, there is a large central laundry room, workshop, and additional storage space. Outside the home are level lawns, mature landscaping, and a sizable deck to enjoy during warmer weather. With walking trails, cross country skiing, and more on the Girl Brook Trail network and shops, restaurants, and area schools just minutes away, this charming family home is a true Hanover gem. A few photos are virtually staged.
Description:Mastlands, named for the towering Eastern white pines once used as ship masts, is a historic Cornish Art Colony estate nestled among trees, farmland, and exquisite gardens. Once the summer home of Dr. Arthur Nichols and his family, it carries a rich legacy, with his daughter, Rose Nichols - a prominent landscape architect - designing the walled garden off the piazza, inspired by her uncle Augustus Saint-Gaudens and architect Charles Platt. The estate's 24 acres feature revived gardens, seasonal blooms, restored fountains, and peaceful retreats like Pine Tree Alley and a firepit. The property offers great outdoor opportunities, with access to a nearby Class 4 road connecting to the scenic River Road, ideal for walks, and additional paths around the cornfields for leisurely strolls. The grand living spaces featuring high ceilings and intricate moldings, including a ballroom wing with elements salvaged from a European chateau, combine historic charm with modern comforts and is crafted for sharing with loved ones. A versatile one-bedroom apartment offers independent living or rental potential, making Mastlands a perfect home for those who cherish history and seek to continue its stewardship. Showings begin 9/3.